﻿<%@ Page Language="C#" MasterPageFile="~/MasterPages/MasterPage.master" AutoEventWireup="true" CodeFile="CoversPriceHistory.aspx.cs" Inherits="Items_CoversPriceHistory" Title="История на Калъфите" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
            СПИСЪК НА КАЛЪФИТЕ<asp:GridView ID="GridViewCovers" runat="server" BackColor="White" 
                BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="4" 
                ForeColor="Black" GridLines="Horizontal" AutoGenerateColumns="False" 
                DataKeyNames="CoverID" DataSourceID="SqlDataSourceCovers" 
                AllowPaging="True">
                <Columns>
                    <asp:BoundField DataField="Code" HeaderText="Code" SortExpression="Code" />
                    <asp:BoundField DataField="NameBG" HeaderText="NameBG" 
                        SortExpression="NameBG" />
                    <asp:BoundField DataField="NameEN" HeaderText="NameEN" 
                        SortExpression="NameEN" />
                    <asp:BoundField DataField="EXW" HeaderText="EXW" SortExpression="EXW" />
                    <asp:BoundField DataField="DDU" HeaderText="DDU" SortExpression="DDU" />
                    <asp:BoundField DataField="Count" HeaderText="Count" SortExpression="Count" />
                    <asp:BoundField DataField="Expense" HeaderText="Expense" 
                        SortExpression="Expense" />
                    <asp:CommandField ShowSelectButton="True" />
                </Columns>
                <FooterStyle BackColor="#CCCC99" ForeColor="Black" />
                <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Right" />
                <SelectedRowStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#333333" Font-Bold="True" ForeColor="White" />
            </asp:GridView>
            <br />
            ИСТОРИЯ<asp:GridView ID="GridViewHistory" runat="server" 
                AutoGenerateColumns="False" BackColor="White" BorderColor="#DEDFDE" 
                BorderStyle="None" BorderWidth="1px" CellPadding="4" 
                DataKeyNames="PriceHistoryCoverID" DataSourceID="SqlDataSourceHistory" 
                ForeColor="Black" GridLines="Vertical">
                <RowStyle BackColor="#F7F7DE" />
                <Columns>
                    <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" />
                    <asp:BoundField DataField="EXW" HeaderText="EXW" SortExpression="EXW" />
                    <asp:BoundField DataField="DDU" HeaderText="DDU" SortExpression="DDU" />
                    <asp:BoundField DataField="Count" HeaderText="Count" SortExpression="Count" />
                    <asp:BoundField DataField="Expense" HeaderText="Expense" 
                        SortExpression="Expense" />
                </Columns>
                <FooterStyle BackColor="#CCCC99" />
                <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
                <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
                <AlternatingRowStyle BackColor="White" />
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSourceHistory" runat="server" 
                ConnectionString="<%$ ConnectionStrings:icodebg_konturConnectionString %>" 
                SelectCommand="SELECT [PriceHistoryCoverID], [CoverID], [Date], [EXW], [DDU], [Count], [Expense] FROM [PriceHistoryCovers] WHERE ([CoverID] = @CoverID)">
                <SelectParameters>
                    <asp:ControlParameter ControlID="GridViewCovers" Name="CoverID" 
                        PropertyName="SelectedValue" />
                </SelectParameters>
            </asp:SqlDataSource>
            <asp:SqlDataSource ID="SqlDataSourceCovers" runat="server" 
                ConnectionString="<%$ ConnectionStrings:icodebg_konturConnectionString %>" 
                SelectCommand="SELECT * FROM [Covers]">
            </asp:SqlDataSource>
        </ContentTemplate>
    </asp:UpdatePanel>
</asp:Content>

